Changing the ODBC data source accessed by a report
Tip: Another way to change a data source is to use the Convert Database Driver option found on the Database menu.
- Choose Set Location from the Database menu.
The Set Location dialog box appears with a list of table aliases for the tables displayed in the report and will display the locations and logon information for the table you select below the list of tables.
- Highlight the first table in this list box.
- Click Set Location.
- Choose the original ODBC data source to log on if you are not logged on already. You must log on to the old data source before you can modify a report to use a new data source. Since you must be logged on to the old data source, the old data source must be available on the local machine.
- Choose the new data source within the Data Explorer dialog box to log on.
You should now be logged on to both the old and the new data sources.
- Double-click the new data source to display its tables, then select the appropriate table from this list. The table you choose should correspond to the first table you selected in the Set Location dialog box.
- After clicking Set the program prompts you to change the location of all tables in the report to the location you specified for the first table.
- Click Yes to set the location of all tables in the report to the same database.
- Close the Set Location dialog box, and choose Verify Database from the Database menu to refresh the table definitions in the report.
- Log off the old data source.
- Save the report.